Profile Report 1

Dataset statistics

Number of variables	32
Number of observations	903653
Missing cells	6389257
Missing cells (%)	22.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 GiB
Average record size in memory	1.4 KiB

Variable types

Categorical	11
DateTime	1
Unsupported	1
Text	10
Numeric	7
Boolean	1
Path	1

Alerts

`adContent` is highly overall correlated with `campaign` and 4 other fields	High correlation
`adwordsClickInfo.adNetworkType` is highly overall correlated with `channelGrouping` and 1 other fields	High correlation
`adwordsClickInfo.page` is highly overall correlated with `channelGrouping` and 1 other fields	High correlation
`adwordsClickInfo.slot` is highly overall correlated with `channelGrouping` and 1 other fields	High correlation
`campaign` is highly overall correlated with `adContent` and 2 other fields	High correlation
`channelGrouping` is highly overall correlated with `adContent` and 5 other fields	High correlation
`continent` is highly overall correlated with `subContinent`	High correlation
`deviceCategory` is highly overall correlated with `isMobile` and 1 other fields	High correlation
`hits` is highly overall correlated with `pageviews`	High correlation
`isMobile` is highly overall correlated with `deviceCategory` and 1 other fields	High correlation
`medium` is highly overall correlated with `adContent` and 5 other fields	High correlation
`operatingSystem` is highly overall correlated with `deviceCategory` and 1 other fields	High correlation
`pageviews` is highly overall correlated with `hits`	High correlation
`subContinent` is highly overall correlated with `continent`	High correlation
`visitId` is highly overall correlated with `adContent` and 1 other fields	High correlation
`visitStartTime` is highly overall correlated with `adContent` and 1 other fields	High correlation
`campaign` is highly imbalanced (90.3%)	Imbalance
`adwordsClickInfo.slot` is highly imbalanced (83.9%)	Imbalance
`adwordsClickInfo.adNetworkType` is highly imbalanced (99.6%)	Imbalance
`conversion` is highly imbalanced (90.2%)	Imbalance
`transactionRevenue` has 892138 (98.7%) missing values	Missing
`keyword` has 502929 (55.7%) missing values	Missing
`referralPath` has 572712 (63.4%) missing values	Missing
`adwordsClickInfo.page` has 882193 (97.6%) missing values	Missing
`adwordsClickInfo.slot` has 882193 (97.6%) missing values	Missing
`adwordsClickInfo.gclId` has 882092 (97.6%) missing values	Missing
`adwordsClickInfo.adNetworkType` has 882193 (97.6%) missing values	Missing
`adContent` has 892707 (98.8%) missing values	Missing
`transactionRevenue` is highly skewed (γ1 = 25.7227026)	Skewed
`adwordsClickInfo.page` is highly skewed (γ1 = 40.17090183)	Skewed
`fullVisitorId` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-02-20 12:38:37.555919
Analysis finished	2024-02-20 12:40:59.337155
Duration	2 minutes and 21.78 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

channelGrouping
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.6 MiB

Organic Search	381561
Social	226117
Direct	143026
Referral	104838
Paid Search	25326
Other values (3)	22785

Length

Max length	14
Median length	11
Mean length	9.8297754
Min length	6

Characters and Unicode

Total characters	8882706
Distinct characters	25
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Organic Search
2nd row	Organic Search
3rd row	Organic Search
4th row	Organic Search
5th row	Organic Search

Common Values

Value	Count	Frequency (%)
Organic Search	381561	42.2%
Social	226117	25.0%
Direct	143026	15.8%
Referral	104838	11.6%
Paid Search	25326	2.8%
Affiliates	16403	1.8%
Display	6262	0.7%
(Other)	120	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
search	406887	31.0%
organic	381561	29.1%
social	226117	17.3%
direct	143026	10.9%
referral	104838	8.0%
paid	25326	1.9%
affiliates	16403	1.3%
display	6262	0.5%
other	120	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	1167394	13.1%
c	1157591	13.0%
r	1141270	12.8%
i	815098	9.2%
e	776112	8.7%
S	633004	7.1%
h	407007	4.6%
	406887	4.6%
O	381681	4.3%
g	381561	4.3%
Other values (15)	1615101	18.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7165039	80.7%
Uppercase Letter	1310540	14.8%
Space Separator	406887	4.6%
Open Punctuation	120	< 0.1%
Close Punctuation	120	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1167394	16.3%
c	1157591	16.2%
r	1141270	15.9%
i	815098	11.4%
e	776112	10.8%
h	407007	5.7%
g	381561	5.3%
n	381561	5.3%
l	353620	4.9%
o	226117	3.2%
Other values (6)	357708	5.0%

Uppercase Letter

Value	Count	Frequency (%)
S	633004	48.3%
O	381681	29.1%
D	149288	11.4%
R	104838	8.0%
P	25326	1.9%
A	16403	1.3%

Space Separator

Value	Count	Frequency (%)
	406887	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	120	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	120	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8475579	95.4%
Common	407127	4.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1167394	13.8%
c	1157591	13.7%
r	1141270	13.5%
i	815098	9.6%
e	776112	9.2%
S	633004	7.5%
h	407007	4.8%
O	381681	4.5%
g	381561	4.5%
n	381561	4.5%
Other values (12)	1233300	14.6%

Common

Value	Count	Frequency (%)
	406887	99.9%
(	120	< 0.1%
)	120	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8882706	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1167394	13.1%
c	1157591	13.0%
r	1141270	12.8%
i	815098	9.2%
e	776112	8.7%
S	633004	7.1%
h	407007	4.6%
	406887	4.6%
O	381681	4.3%
g	381561	4.3%
Other values (15)	1615101	18.2%

date
Date

Distinct	366
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Minimum	1970-01-01 00:00:00.020160
Maximum	1970-01-01 00:00:00.020170

Histogram

Histogram with fixed size bins (bins=50)

fullVisitorId
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	38.7 MiB

sessionId
Text

Distinct	902755
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	74.9 MiB

Length

Max length	31
Median length	30
Mean length	29.878958
Min length	24

Characters and Unicode

Total characters	27000210
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	901857 ?
Unique (%)	99.8%

Sample

1st row	1131660440785968503_1472830385
2nd row	377306020877927890_1472880147
3rd row	3895546263509774583_1472865386
4th row	4763447161404445595_1472881213
5th row	27294437909732085_1472822600

Value	Count	Frequency (%)
14108533830165900_1482391162	2	< 0.1%
7328657227470299189_1488700723	2	< 0.1%
2896409751679637889_1497249098	2	< 0.1%
1920231893487967243_1494224540	2	< 0.1%
9328692348677910181_1490338007	2	< 0.1%
2936634930290678437_1486195062	2	< 0.1%
3332070148916030858_1488700627	2	< 0.1%
31144590393948452_1499929196	2	< 0.1%
4203774291422453000_1499065071	2	< 0.1%
0461869076077289632_1495090739	2	< 0.1%
Other values (902745)	903633	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	3250435	12.0%
4	3181333	11.8%
7	2672658	9.9%
8	2612708	9.7%
9	2597893	9.6%
0	2417472	9.0%
5	2378325	8.8%
6	2333813	8.6%
3	2329535	8.6%
2	2322385	8.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26096557	96.7%
Connector Punctuation	903653	3.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	3250435	12.5%
4	3181333	12.2%
7	2672658	10.2%
8	2612708	10.0%
9	2597893	10.0%
0	2417472	9.3%
5	2378325	9.1%
6	2333813	8.9%
3	2329535	8.9%
2	2322385	8.9%

Connector Punctuation

Value	Count	Frequency (%)
_	903653	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	27000210	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	3250435	12.0%
4	3181333	11.8%
7	2672658	9.9%
8	2612708	9.7%
9	2597893	9.6%
0	2417472	9.0%
5	2378325	8.8%
6	2333813	8.6%
3	2329535	8.6%
2	2322385	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27000210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3250435	12.0%
4	3181333	11.8%
7	2672658	9.9%
8	2612708	9.7%
9	2597893	9.6%
0	2417472	9.0%
5	2378325	8.8%
6	2333813	8.6%
3	2329535	8.6%
2	2322385	8.6%

visitId
Real number (ℝ)

HIGH CORRELATION

Distinct	886303
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4850073 × 10⁹

Minimum	1.4700348 × 10⁹
Maximum	1.5016572 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1.4700348 × 10⁹
5-th percentile	1.4716204 × 10⁹
Q1	1.4775612 × 10⁹
median	1.4839487 × 10⁹
Q3	1.4927588 × 10⁹
95-th percentile	1.4999783 × 10⁹
Maximum	1.5016572 × 10⁹
Range	31622381
Interquartile range (IQR)	15197593

Descriptive statistics

Standard deviation	9022123.6
Coefficient of variation (CV)	0.0060754743
Kurtosis	-1.1657356
Mean	1.4850073 × 10⁹
Median Absolute Deviation (MAD)	7323946
Skewness	0.19405148
Sum	1.3419313 × 10¹⁵
Variance	8.1398713 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1493146175	8	< 0.1%
1478345904	6	< 0.1%
1481369525	6	< 0.1%
1484649802	6	< 0.1%
1500856602	5	< 0.1%
1494374199	5	< 0.1%
1495031359	5	< 0.1%
1488904421	4	< 0.1%
1481365730	4	< 0.1%
1488190236	4	< 0.1%
Other values (886293)	903600	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1470034812	1	< 0.1%
1470035066	1	< 0.1%
1470035081	1	< 0.1%
1470035161	1	< 0.1%
1470035170	1	< 0.1%
1470035292	1	< 0.1%
1470035429	1	< 0.1%
1470035457	1	< 0.1%
1470035501	1	< 0.1%
1470035521	1	< 0.1%

Value	Count	Frequency (%)
1501657193	1	< 0.1%
1501657190	1	< 0.1%
1501657186	1	< 0.1%
1501657166	1	< 0.1%
1501657161	1	< 0.1%
1501657013	1	< 0.1%
1501656998	1	< 0.1%
1501656981	1	< 0.1%
1501656976	1	< 0.1%
1501656970	1	< 0.1%

visitNumber
Real number (ℝ)

Distinct	384
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.264897

Minimum	1
Maximum	395
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	5
Maximum	395
Range	394
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	9.2837345
Coefficient of variation (CV)	4.0989654
Kurtosis	517.3079
Mean	2.264897
Median Absolute Deviation (MAD)	0
Skewness	19.998064
Sum	2046681
Variance	86.187726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	703060	77.8%
2	92548	10.2%
3	35843	4.0%
4	19157	2.1%
5	11615	1.3%
6	7677	0.8%
7	5413	0.6%
8	4031	0.4%
9	3084	0.3%
10	2415	0.3%
Other values (374)	18810	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	703060	77.8%
2	92548	10.2%
3	35843	4.0%
4	19157	2.1%
5	11615	1.3%
6	7677	0.8%
7	5413	0.6%
8	4031	0.4%
9	3084	0.3%
10	2415	0.3%

Value	Count	Frequency (%)
395	1	< 0.1%
394	1	< 0.1%
393	1	< 0.1%
391	1	< 0.1%
390	1	< 0.1%
389	1	< 0.1%
388	1	< 0.1%
387	1	< 0.1%
386	1	< 0.1%
385	1	< 0.1%

visitStartTime
Real number (ℝ)

HIGH CORRELATION

Distinct	887159
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4850073 × 10⁹

Minimum	1.4700348 × 10⁹
Maximum	1.5016572 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1.4700348 × 10⁹
5-th percentile	1.4716204 × 10⁹
Q1	1.4775612 × 10⁹
median	1.4839489 × 10⁹
Q3	1.4927588 × 10⁹
95-th percentile	1.4999783 × 10⁹
Maximum	1.5016572 × 10⁹
Range	31622381
Interquartile range (IQR)	15197593

Descriptive statistics

Standard deviation	9022123.7
Coefficient of variation (CV)	0.0060754743
Kurtosis	-1.1657356
Mean	1.4850073 × 10⁹
Median Absolute Deviation (MAD)	7323976
Skewness	0.19405153
Sum	1.3419313 × 10¹⁵
Variance	8.1398716 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1493146175	8	< 0.1%
1478345904	6	< 0.1%
1484649802	6	< 0.1%
1481369525	6	< 0.1%
1495031359	5	< 0.1%
1500856602	5	< 0.1%
1494374199	5	< 0.1%
1490274633	4	< 0.1%
1494590623	4	< 0.1%
1490264449	4	< 0.1%
Other values (887149)	903600	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1470034812	1	< 0.1%
1470035066	1	< 0.1%
1470035081	1	< 0.1%
1470035161	1	< 0.1%
1470035170	1	< 0.1%
1470035292	1	< 0.1%
1470035429	1	< 0.1%
1470035457	1	< 0.1%
1470035501	1	< 0.1%
1470035521	1	< 0.1%

Value	Count	Frequency (%)
1501657193	1	< 0.1%
1501657190	1	< 0.1%
1501657186	1	< 0.1%
1501657166	1	< 0.1%
1501657161	1	< 0.1%
1501657013	1	< 0.1%
1501656998	1	< 0.1%
1501656981	1	< 0.1%
1501656976	1	< 0.1%
1501656970	1	< 0.1%

continent
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.7 MiB

Americas	450377
Asia	223698
Europe	198311
Oceania	15054
Africa	14745

Length

Max length	9
Median length	8
Mean length	6.5232274
Min length	4

Characters and Unicode

Total characters	5894734
Distinct characters	19
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Asia
2nd row	Oceania
3rd row	Europe
4th row	Asia
5th row	Europe

Common Values

Value	Count	Frequency (%)
Americas	450377	49.8%
Asia	223698	24.8%
Europe	198311	21.9%
Oceania	15054	1.7%
Africa	14745	1.6%
(not set)	1468	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
americas	450377	49.8%
asia	223698	24.7%
europe	198311	21.9%
oceania	15054	1.7%
africa	14745	1.6%
not	1468	0.2%
set	1468	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	718928	12.2%
i	703874	11.9%
A	688820	11.7%
s	675543	11.5%
e	665210	11.3%
r	663433	11.3%
c	480176	8.1%
m	450377	7.6%
o	199779	3.4%
p	198311	3.4%
Other values (9)	450283	7.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4988145	84.6%
Uppercase Letter	902185	15.3%
Open Punctuation	1468	< 0.1%
Space Separator	1468	< 0.1%
Close Punctuation	1468	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	718928	14.4%
i	703874	14.1%
s	675543	13.5%
e	665210	13.3%
r	663433	13.3%
c	480176	9.6%
m	450377	9.0%
o	199779	4.0%
p	198311	4.0%
u	198311	4.0%
Other values (3)	34203	0.7%

Uppercase Letter

Value	Count	Frequency (%)
A	688820	76.4%
E	198311	22.0%
O	15054	1.7%

Open Punctuation

Value	Count	Frequency (%)
(	1468	100.0%

Space Separator

Value	Count	Frequency (%)
	1468	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5890330	99.9%
Common	4404	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	718928	12.2%
i	703874	11.9%
A	688820	11.7%
s	675543	11.5%
e	665210	11.3%
r	663433	11.3%
c	480176	8.2%
m	450377	7.6%
o	199779	3.4%
p	198311	3.4%
Other values (6)	445879	7.6%

Common

Value	Count	Frequency (%)
(	1468	33.3%
	1468	33.3%
)	1468	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5894734	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	718928	12.2%
i	703874	11.9%
A	688820	11.7%
s	675543	11.5%
e	665210	11.3%
r	663433	11.3%
c	480176	8.1%
m	450377	7.6%
o	199779	3.4%
p	198311	3.4%
Other values (9)	450283	7.6%

subContinent
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.7 MiB

Northern America	390657
Southeast Asia	77800
Southern Asia	59321
Western Europe	59114
Northern Europe	58168
Other values (18)	258593

Length

Max length	18
Median length	16
Mean length	14.621631
Min length	9

Characters and Unicode

Total characters	13212881
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Western Asia
2nd row	Australasia
3rd row	Southern Europe
4th row	Southeast Asia
5th row	Northern Europe

Common Values

Value	Count	Frequency (%)
Northern America	390657	43.2%
Southeast Asia	77800	8.6%
Southern Asia	59321	6.6%
Western Europe	59114	6.5%
Northern Europe	58168	6.4%
Eastern Asia	46919	5.2%
Eastern Europe	45249	5.0%
South America	41731	4.6%
Western Asia	38443	4.3%
Southern Europe	35780	4.0%
Other values (13)	50471	5.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
northern	456508	25.5%
america	447971	25.0%
asia	223698	12.5%
europe	198311	11.1%
western	100130	5.6%
southern	97270	5.4%
eastern	94095	5.3%
southeast	77800	4.3%
south	41731	2.3%
central	16798	0.9%
Other values (10)	35589	2.0%

Most occurring characters

Value	Count	Frequency (%)
r	1899690	14.4%
e	1593577	12.1%
t	979961	7.4%
a	924840	7.0%
	886248	6.7%
o	873223	6.6%
n	768946	5.8%
i	704377	5.3%
A	701307	5.3%
h	673309	5.1%
Other values (21)	3207403	24.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10536732	79.7%
Uppercase Letter	1786965	13.5%
Space Separator	886248	6.7%
Open Punctuation	1468	< 0.1%
Close Punctuation	1468	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1899690	18.0%
e	1593577	15.1%
t	979961	9.3%
a	924840	8.8%
o	873223	8.3%
n	768946	7.3%
i	704377	6.7%
h	673309	6.4%
s	527138	5.0%
c	462771	4.4%
Other values (9)	1128900	10.7%

Uppercase Letter

Value	Count	Frequency (%)
A	701307	39.2%
N	456508	25.5%
E	292406	16.4%
S	216801	12.1%
W	100130	5.6%
C	19204	1.1%
M	529	< 0.1%
R	55	< 0.1%
P	25	< 0.1%

Space Separator

Value	Count	Frequency (%)
	886248	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1468	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1468	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12323697	93.3%
Common	889184	6.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1899690	15.4%
e	1593577	12.9%
t	979961	8.0%
a	924840	7.5%
o	873223	7.1%
n	768946	6.2%
i	704377	5.7%
A	701307	5.7%
h	673309	5.5%
s	527138	4.3%
Other values (18)	2677329	21.7%

Common

Value	Count	Frequency (%)
	886248	99.7%
(	1468	0.2%
)	1468	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13212881	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1899690	14.4%
e	1593577	12.1%
t	979961	7.4%
a	924840	7.0%
	886248	6.7%
o	873223	6.6%
n	768946	5.8%
i	704377	5.3%
A	701307	5.3%
h	673309	5.1%
Other values (21)	3207403	24.3%

country
Text

Distinct	222
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.5 MiB

Length

Max length	24
Median length	22
Mean length	9.7230386
Min length	4

Characters and Unicode

Total characters	8786253
Distinct characters	63
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	Turkey
2nd row	Australia
3rd row	Spain
4th row	Indonesia
5th row	United Kingdom

Value	Count	Frequency (%)
united	405281	30.3%
states	364744	27.2%
india	51140	3.8%
kingdom	37393	2.8%
canada	25869	1.9%
vietnam	24598	1.8%
turkey	20522	1.5%
thailand	20123	1.5%
germany	19980	1.5%
brazil	19783	1.5%
Other values (252)	349718	26.1%

Most occurring characters

Value	Count	Frequency (%)
t	1238439	14.1%
e	1021620	11.6%
a	965182	11.0%
n	792306	9.0%
i	766000	8.7%
d	601015	6.8%
s	464391	5.3%
	435498	5.0%
U	411769	4.7%
S	410463	4.7%
Other values (53)	1679570	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7005686	79.7%
Uppercase Letter	1338417	15.2%
Space Separator	435498	5.0%
Open Punctuation	2510	< 0.1%
Close Punctuation	2510	< 0.1%
Other Punctuation	1195	< 0.1%
Final Punctuation	320	< 0.1%
Dash Punctuation	117	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1238439	17.7%
e	1021620	14.6%
a	965182	13.8%
n	792306	11.3%
i	766000	10.9%
d	601015	8.6%
s	464391	6.6%
r	198000	2.8%
l	151162	2.2%
o	146869	2.1%
Other values (21)	660702	9.4%

Uppercase Letter

Value	Count	Frequency (%)
U	411769	30.8%
S	410463	30.7%
I	85110	6.4%
T	55494	4.1%
K	50288	3.8%
C	44495	3.3%
A	32529	2.4%
P	32433	2.4%
B	31573	2.4%
V	26788	2.0%
Other values (15)	157475	11.8%

Other Punctuation

Value	Count	Frequency (%)
&	1106	92.6%
.	89	7.4%

Space Separator

Value	Count	Frequency (%)
	435498	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2510	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2510	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	320	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	117	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8344103	95.0%
Common	442150	5.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1238439	14.8%
e	1021620	12.2%
a	965182	11.6%
n	792306	9.5%
i	766000	9.2%
d	601015	7.2%
s	464391	5.6%
U	411769	4.9%
S	410463	4.9%
r	198000	2.4%
Other values (46)	1474918	17.7%

Common

Value	Count	Frequency (%)
	435498	98.5%
(	2510	0.6%
)	2510	0.6%
&	1106	0.3%
’	320	0.1%
-	117	< 0.1%
.	89	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8785433	> 99.9%
None	500	< 0.1%
Punctuation	320	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1238439	14.1%
e	1021620	11.6%
a	965182	11.0%
n	792306	9.0%
i	766000	8.7%
d	601015	6.8%
s	464391	5.3%
	435498	5.0%
U	411769	4.7%
S	410463	4.7%
Other values (46)	1678750	19.1%

None

Value	Count	Frequency (%)
ô	320	64.0%
é	147	29.4%
ç	30	6.0%
ã	1	0.2%
í	1	0.2%
Å	1	0.2%

Punctuation

Value	Count	Frequency (%)
’	320	100.0%

region
Text

Distinct	376
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	66.9 MiB

Length

Max length	33
Median length	29
Mean length	20.613868
Min length	4

Characters and Unicode

Total characters	18627784
Distinct characters	56
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Izmir
2nd row	not available in demo dataset
3rd row	Community of Madrid
4th row	not available in demo dataset
5th row	not available in demo dataset

Value	Count	Frequency (%)
not	536056	17.2%
available	508229	16.3%
in	508229	16.3%
demo	508229	16.3%
dataset	508229	16.3%
california	107501	3.4%
new	33063	1.1%
set	27827	0.9%
york	26433	0.8%
of	13607	0.4%
Other values (452)	342152	11.0%

Most occurring characters

Value	Count	Frequency (%)
a	3037450	16.3%
	2215902	11.9%
e	1709137	9.2%
t	1704294	9.1%
i	1434438	7.7%
o	1338634	7.2%
n	1327976	7.1%
l	1227746	6.6%
d	1063436	5.7%
s	629109	3.4%
Other values (46)	2939662	15.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15832688	85.0%
Space Separator	2215902	11.9%
Uppercase Letter	512694	2.8%
Close Punctuation	27827	0.1%
Open Punctuation	27827	0.1%
Dash Punctuation	10582	0.1%
Other Punctuation	264	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3037450	19.2%
e	1709137	10.8%
t	1704294	10.8%
i	1434438	9.1%
o	1338634	8.5%
n	1327976	8.4%
l	1227746	7.8%
d	1063436	6.7%
s	629109	4.0%
m	532538	3.4%
Other values (16)	1827930	11.5%

Uppercase Letter

Value	Count	Frequency (%)
C	145934	28.5%
N	43828	8.5%
M	36782	7.2%
T	35969	7.0%
Y	26465	5.2%
D	21969	4.3%
S	21727	4.2%
I	19813	3.9%
B	19351	3.8%
H	17118	3.3%
Other values (15)	123738	24.1%

Space Separator

Value	Count	Frequency (%)
	2215902	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	27827	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	27827	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10582	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	264	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16345382	87.7%
Common	2282402	12.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3037450	18.6%
e	1709137	10.5%
t	1704294	10.4%
i	1434438	8.8%
o	1338634	8.2%
n	1327976	8.1%
l	1227746	7.5%
d	1063436	6.5%
s	629109	3.8%
m	532538	3.3%
Other values (41)	2340624	14.3%

Common

Value	Count	Frequency (%)
	2215902	97.1%
)	27827	1.2%
(	27827	1.2%
-	10582	0.5%
'	264	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18627784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3037450	16.3%
	2215902	11.9%
e	1709137	9.2%
t	1704294	9.1%
i	1434438	7.7%
o	1338634	7.2%
n	1327976	7.1%
l	1227746	6.6%
d	1063436	5.7%
s	629109	3.4%
Other values (46)	2939662	15.8%

metro
Text

Distinct	94
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	69.1 MiB

Length

Max length	41
Median length	29
Mean length	23.187242
Min length	6

Characters and Unicode

Total characters	20953221
Distinct characters	57
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	(not set)
2nd row	not available in demo dataset
3rd row	(not set)
4th row	not available in demo dataset
5th row	not available in demo dataset

Value	Count	Frequency (%)
not	709995	19.9%
in	508284	14.3%
available	508229	14.3%
demo	508229	14.3%
dataset	508229	14.3%
set	201766	5.7%
ca	107495	3.0%
san	97670	2.7%
francisco-oakland-san	95913	2.7%
jose	95913	2.7%
Other values (161)	221970	6.2%

Most occurring characters

Value	Count	Frequency (%)
a	3084714	14.7%
	2660040	12.7%
t	1983594	9.5%
e	1908676	9.1%
n	1674938	8.0%
o	1522326	7.3%
l	1144979	5.5%
i	1137893	5.4%
d	1129116	5.4%
s	947069	4.5%
Other values (47)	3759876	17.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16654529	79.5%
Space Separator	2660040	12.7%
Uppercase Letter	1015958	4.8%
Dash Punctuation	208990	1.0%
Open Punctuation	205397	1.0%
Close Punctuation	205397	1.0%
Other Punctuation	2593	< 0.1%
Connector Punctuation	317	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	201944	19.9%
A	142147	14.0%
C	122747	12.1%
O	99783	9.8%
F	98863	9.7%
J	96257	9.5%
N	58712	5.8%
Y	54047	5.3%
L	33820	3.3%
T	17187	1.7%
Other values (15)	90451	8.9%

Lowercase Letter

Value	Count	Frequency (%)
a	3084714	18.5%
t	1983594	11.9%
e	1908676	11.5%
n	1674938	10.1%
o	1522326	9.1%
l	1144979	6.9%
i	1137893	6.8%
d	1129116	6.8%
s	947069	5.7%
m	517042	3.1%
Other values (14)	1604182	9.6%

Other Punctuation

Value	Count	Frequency (%)
.	2520	97.2%
&	61	2.4%
,	12	0.5%

Space Separator

Value	Count	Frequency (%)
	2660040	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	208990	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	205397	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	205397	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	317	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17670487	84.3%
Common	3282734	15.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3084714	17.5%
t	1983594	11.2%
e	1908676	10.8%
n	1674938	9.5%
o	1522326	8.6%
l	1144979	6.5%
i	1137893	6.4%
d	1129116	6.4%
s	947069	5.4%
m	517042	2.9%
Other values (39)	2620140	14.8%

Common

Value	Count	Frequency (%)
	2660040	81.0%
-	208990	6.4%
(	205397	6.3%
)	205397	6.3%
.	2520	0.1%
_	317	< 0.1%
&	61	< 0.1%
,	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20953221	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3084714	14.7%
	2660040	12.7%
t	1983594	9.5%
e	1908676	9.1%
n	1674938	8.0%
o	1522326	7.3%
l	1144979	5.5%
i	1137893	5.4%
d	1129116	5.4%
s	947069	4.5%
Other values (47)	3759876	17.9%

city
Text

Distinct	649
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	66.5 MiB

Length

Max length	33
Median length	29
Mean length	20.198846
Min length	3

Characters and Unicode

Total characters	18252748
Distinct characters	58
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Izmir
2nd row	not available in demo dataset
3rd row	Madrid
4th row	not available in demo dataset
5th row	not available in demo dataset

Value	Count	Frequency (%)
not	542491	17.2%
available	508229	16.1%
in	508229	16.1%
demo	508229	16.1%
dataset	508229	16.1%
mountain	40884	1.3%
view	40884	1.3%
san	34510	1.1%
set	34262	1.1%
new	29593	0.9%
Other values (729)	392267	12.5%

Most occurring characters

Value	Count	Frequency (%)
a	2851125	15.6%
	2244154	12.3%
e	1772459	9.7%
t	1723610	9.4%
n	1388588	7.6%
o	1327491	7.3%
i	1247087	6.8%
l	1121717	6.1%
d	1065724	5.8%
s	638731	3.5%
Other values (48)	2872062	15.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15395189	84.3%
Space Separator	2244154	12.3%
Uppercase Letter	540915	3.0%
Close Punctuation	34262	0.2%
Open Punctuation	34262	0.2%
Dash Punctuation	3850	< 0.1%
Other Punctuation	116	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2851125	18.5%
e	1772459	11.5%
t	1723610	11.2%
n	1388588	9.0%
o	1327491	8.6%
i	1247087	8.1%
l	1121717	7.3%
d	1065724	6.9%
s	638731	4.1%
b	545505	3.5%
Other values (17)	1713152	11.1%

Uppercase Letter

Value	Count	Frequency (%)
S	77212	14.3%
M	73829	13.6%
V	44431	8.2%
C	42122	7.8%
A	34771	6.4%
N	32069	5.9%
Y	30238	5.6%
B	29697	5.5%
L	27718	5.1%
H	25297	4.7%
Other values (15)	123531	22.8%

Other Punctuation

Value	Count	Frequency (%)
'	92	79.3%
.	24	20.7%

Space Separator

Value	Count	Frequency (%)
	2244154	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	34262	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	34262	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3850	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15936104	87.3%
Common	2316644	12.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2851125	17.9%
e	1772459	11.1%
t	1723610	10.8%
n	1388588	8.7%
o	1327491	8.3%
i	1247087	7.8%
l	1121717	7.0%
d	1065724	6.7%
s	638731	4.0%
b	545505	3.4%
Other values (42)	2254067	14.1%

Common

Value	Count	Frequency (%)
	2244154	96.9%
)	34262	1.5%
(	34262	1.5%
-	3850	0.2%
'	92	< 0.1%
.	24	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18252664	> 99.9%
None	84	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2851125	15.6%
	2244154	12.3%
e	1772459	9.7%
t	1723610	9.4%
n	1388588	7.6%
o	1327491	7.3%
i	1247087	6.8%
l	1121717	6.1%
d	1065724	5.8%
s	638731	3.5%
Other values (47)	2871978	15.7%

None

Value	Count	Frequency (%)
ã	84	100.0%

networkDomain
Text

Distinct	28064
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	58.9 MiB

Length

Max length	37
Median length	36
Mean length	11.307548
Min length	2

Characters and Unicode

Total characters	10218100
Distinct characters	44
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14649 ?
Unique (%)	1.6%

Sample

1st row	ttnet.com.tr
2nd row	dodo.net.au
3rd row	unknown.unknown
4th row	unknown.unknown
5th row	unknown.unknown

Value	Count	Frequency (%)
not	244881	21.3%
set	244881	21.3%
unknown.unknown	146034	12.7%
comcast.net	28743	2.5%
rr.com	14827	1.3%
verizon.net	13637	1.2%
ttnet.com.tr	13228	1.2%
comcastbusiness.net	9985	0.9%
hinet.net	7919	0.7%
virginm.net	6414	0.6%
Other values (28055)	417985	36.4%

Most occurring characters

Value	Count	Frequency (%)
n	1652112	16.2%
t	1109389	10.9%
o	976560	9.6%
e	853294	8.4%
.	764746	7.5%
s	481477	4.7%
u	410558	4.0%
c	386518	3.8%
w	332859	3.3%
k	332681	3.3%
Other values (34)	2917906	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8642089	84.6%
Other Punctuation	764767	7.5%
Open Punctuation	244881	2.4%
Close Punctuation	244881	2.4%
Space Separator	244881	2.4%
Decimal Number	39097	0.4%
Dash Punctuation	37500	0.4%
Connector Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	1652112	19.1%
t	1109389	12.8%
o	976560	11.3%
e	853294	9.9%
s	481477	5.6%
u	410558	4.8%
c	386518	4.5%
w	332859	3.9%
k	332681	3.8%
a	310767	3.6%
Other values (16)	1795874	20.8%

Decimal Number

Value	Count	Frequency (%)
3	9720	24.9%
1	6911	17.7%
2	6125	15.7%
5	4066	10.4%
0	3520	9.0%
8	3008	7.7%
4	2346	6.0%
9	1865	4.8%
6	857	2.2%
7	679	1.7%

Other Punctuation

Value	Count	Frequency (%)
.	764746	> 99.9%
\	13	< 0.1%
@	8	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	244881	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	244881	100.0%

Space Separator

Value	Count	Frequency (%)
	244881	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	37500	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8642089	84.6%
Common	1576011	15.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	1652112	19.1%
t	1109389	12.8%
o	976560	11.3%
e	853294	9.9%
s	481477	5.6%
u	410558	4.8%
c	386518	4.5%
w	332859	3.9%
k	332681	3.8%
a	310767	3.6%
Other values (16)	1795874	20.8%

Common

Value	Count	Frequency (%)
.	764746	48.5%
(	244881	15.5%
)	244881	15.5%
	244881	15.5%
-	37500	2.4%
3	9720	0.6%
1	6911	0.4%
2	6125	0.4%
5	4066	0.3%
0	3520	0.2%
Other values (8)	8780	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10218100	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	1652112	16.2%
t	1109389	10.9%
o	976560	9.6%
e	853294	8.4%
.	764746	7.5%
s	481477	4.7%
u	410558	4.0%
c	386518	3.8%
w	332859	3.3%
k	332681	3.3%
Other values (34)	2917906	28.6%

browser
Text

Distinct	54
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.7 MiB

Length

Max length	43
Median length	6
Mean length	6.460627
Min length	1

Characters and Unicode

Total characters	5838165
Distinct characters	68
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	Firefox
3rd row	Chrome
4th row	UC Browser
5th row	Chrome

Value	Count	Frequency (%)
chrome	620365	65.4%
safari	189095	19.9%
firefox	37069	3.9%
internet	19375	2.0%
explorer	19375	2.0%
opera	11782	1.2%
edge	10205	1.1%
android	8420	0.9%
webview	7865	0.8%
in-app	6850	0.7%
Other values (60)	18727	2.0%

Most occurring characters

Value	Count	Frequency (%)
r	935843	16.0%
e	759760	13.0%
o	693831	11.9%
C	624899	10.7%
m	621325	10.6%
h	620632	10.6%
a	400787	6.9%
i	263237	4.5%
f	226356	3.9%
S	189714	3.2%
Other values (58)	501781	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4822831	82.6%
Uppercase Letter	948991	16.3%
Space Separator	45475	0.8%
Dash Punctuation	6866	0.1%
Open Punctuation	6859	0.1%
Close Punctuation	6859	0.1%
Decimal Number	201	< 0.1%
Connector Punctuation	82	< 0.1%
Other Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	935843	19.4%
e	759760	15.8%
o	693831	14.4%
m	621325	12.9%
h	620632	12.9%
a	400787	8.3%
i	263237	5.5%
f	226356	4.7%
n	61814	1.3%
x	56690	1.2%
Other values (16)	182556	3.8%

Uppercase Letter

Value	Count	Frequency (%)
C	624899	65.8%
S	189714	20.0%
F	37094	3.9%
E	29851	3.1%
I	19410	2.0%
O	12046	1.3%
A	9371	1.0%
W	7865	0.8%
M	7320	0.8%
B	5654	0.6%
Other values (14)	5767	0.6%

Decimal Number

Value	Count	Frequency (%)
2	63	31.3%
0	59	29.4%
1	29	14.4%
4	24	11.9%
7	10	5.0%
5	6	3.0%
3	4	2.0%
9	4	2.0%
8	1	0.5%
6	1	0.5%

Open Punctuation

Value	Count	Frequency (%)
(	6858	> 99.9%
[	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	6858	> 99.9%
]	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	45475	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6866	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	82	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5771822	98.9%
Common	66343	1.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	935843	16.2%
e	759760	13.2%
o	693831	12.0%
C	624899	10.8%
m	621325	10.8%
h	620632	10.8%
a	400787	6.9%
i	263237	4.6%
f	226356	3.9%
S	189714	3.3%
Other values (40)	435438	7.5%

Common

Value	Count	Frequency (%)
	45475	68.5%
-	6866	10.3%
(	6858	10.3%
)	6858	10.3%
_	82	0.1%
2	63	0.1%
0	59	0.1%
1	29	< 0.1%
4	24	< 0.1%
7	10	< 0.1%
Other values (8)	19	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5838165	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	935843	16.0%
e	759760	13.0%
o	693831	11.9%
C	624899	10.7%
m	621325	10.6%
h	620632	10.6%
a	400787	6.9%
i	263237	4.5%
f	226356	3.9%
S	189714	3.2%
Other values (58)	501781	8.6%

operatingSystem
Categorical

HIGH CORRELATION

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.2 MiB

Windows	350072
Macintosh	253938
Android	123892
iOS	107665
Linux	35034
Other values (15)	33052

Length

Max length	13
Median length	7
Mean length	7.0862532
Min length	3

Characters and Unicode

Total characters	6403514
Distinct characters	41
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Windows
2nd row	Macintosh
3rd row	Windows
4th row	Linux
5th row	Android

Common Values

Value	Count	Frequency (%)
Windows	350072	38.7%
Macintosh	253938	28.1%
Android	123892	13.7%
iOS	107665	11.9%
Linux	35034	3.9%
Chrome OS	26337	2.9%
(not set)	4695	0.5%
Windows Phone	1216	0.1%
Samsung	280	< 0.1%
BlackBerry	218	< 0.1%
Other values (10)	306	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
windows	351288	37.5%
macintosh	253938	27.1%
android	123892	13.2%
ios	107665	11.5%
linux	35034	3.7%
os	26426	2.8%
chrome	26337	2.8%
not	4695	0.5%
set	4695	0.5%
phone	1216	0.1%
Other values (14)	941	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	872314	13.6%
n	770618	12.0%
o	761662	11.9%
s	610201	9.5%
d	599208	9.4%
W	351423	5.5%
w	351288	5.5%
h	281491	4.4%
t	263464	4.1%
a	254438	4.0%
Other values (31)	1287407	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5300528	82.8%
Uppercase Letter	1061121	16.6%
Space Separator	32474	0.5%
Open Punctuation	4695	0.1%
Close Punctuation	4695	0.1%
Decimal Number	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	872314	16.5%
n	770618	14.5%
o	761662	14.4%
s	610201	11.5%
d	599208	11.3%
w	351288	6.6%
h	281491	5.3%
t	263464	5.0%
a	254438	4.8%
c	254156	4.8%
Other values (12)	281688	5.3%

Uppercase Letter

Value	Count	Frequency (%)
W	351423	33.1%
M	253939	23.9%
S	134385	12.7%
O	134094	12.6%
A	123892	11.7%
L	35034	3.3%
C	26338	2.5%
P	1216	0.1%
B	447	< 0.1%
N	139	< 0.1%
Other values (5)	214	< 0.1%

Space Separator

Value	Count	Frequency (%)
	32474	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	4695	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4695	100.0%

Decimal Number

Value	Count	Frequency (%)
3	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6361649	99.3%
Common	41865	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	872314	13.7%
n	770618	12.1%
o	761662	12.0%
s	610201	9.6%
d	599208	9.4%
W	351423	5.5%
w	351288	5.5%
h	281491	4.4%
t	263464	4.1%
a	254438	4.0%
Other values (27)	1245542	19.6%

Common

Value	Count	Frequency (%)
	32474	77.6%
(	4695	11.2%
)	4695	11.2%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6403514	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	872314	13.6%
n	770618	12.0%
o	761662	11.9%
s	610201	9.5%
d	599208	9.4%
W	351423	5.5%
w	351288	5.5%
h	281491	4.4%
t	263464	4.1%
a	254438	4.0%
Other values (31)	1287407	20.1%

isMobile
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	882.6 KiB

False	664530
True	239123

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	664530	73.5%
True	239123	26.5%

deviceCategory
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.9 MiB

desktop	664479
mobile	208725
tablet	30449

Length

Max length	7
Median length	7
Mean length	6.7353254
Min length	6

Characters and Unicode

Total characters	6086397
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	desktop
2nd row	desktop
3rd row	desktop
4th row	desktop
5th row	mobile

Common Values

Value	Count	Frequency (%)
desktop	664479	73.5%
mobile	208725	23.1%
tablet	30449	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
desktop	664479	73.5%
mobile	208725	23.1%
tablet	30449	3.4%

Most occurring characters

Value	Count	Frequency (%)
e	903653	14.8%
o	873204	14.3%
t	725377	11.9%
d	664479	10.9%
s	664479	10.9%
k	664479	10.9%
p	664479	10.9%
b	239174	3.9%
l	239174	3.9%
m	208725	3.4%
Other values (2)	239174	3.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6086397	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	903653	14.8%
o	873204	14.3%
t	725377	11.9%
d	664479	10.9%
s	664479	10.9%
k	664479	10.9%
p	664479	10.9%
b	239174	3.9%
l	239174	3.9%
m	208725	3.4%
Other values (2)	239174	3.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6086397	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	903653	14.8%
o	873204	14.3%
t	725377	11.9%
d	664479	10.9%
s	664479	10.9%
k	664479	10.9%
p	664479	10.9%
b	239174	3.9%
l	239174	3.9%
m	208725	3.4%
Other values (2)	239174	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6086397	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	903653	14.8%
o	873204	14.3%
t	725377	11.9%
d	664479	10.9%
s	664479	10.9%
k	664479	10.9%
p	664479	10.9%
b	239174	3.9%
l	239174	3.9%
m	208725	3.4%
Other values (2)	239174	3.9%

hits
Real number (ℝ)

HIGH CORRELATION

Distinct	274
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5965376

Minimum	1
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	18
Maximum	500
Range	499
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	9.6414371
Coefficient of variation (CV)	2.0975434
Kurtosis	230.35198
Mean	4.5965376
Median Absolute Deviation (MAD)	1
Skewness	9.7804556
Sum	4153675
Variance	92.957308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	446754	49.4%
2	137952	15.3%
3	70402	7.8%
4	42444	4.7%
5	30939	3.4%
6	23918	2.6%
7	19518	2.2%
8	15484	1.7%
9	12959	1.4%
10	10640	1.2%
Other values (264)	92643	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	446754	49.4%
2	137952	15.3%
3	70402	7.8%
4	42444	4.7%
5	30939	3.4%
6	23918	2.6%
7	19518	2.2%
8	15484	1.7%
9	12959	1.4%
10	10640	1.2%

Value	Count	Frequency (%)
500	10	< 0.1%
489	1	< 0.1%
483	1	< 0.1%
471	1	< 0.1%
445	1	< 0.1%
437	1	< 0.1%
406	1	< 0.1%
387	1	< 0.1%
386	1	< 0.1%
385	2	< 0.1%

pageviews
Real number (ℝ)

HIGH CORRELATION

Distinct	213
Distinct (%)	< 0.1%
Missing	100
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.8497642

Minimum	1
Maximum	469
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	15
Maximum	469
Range	468
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	7.025274
Coefficient of variation (CV)	1.8248582
Kurtosis	237.41488
Mean	3.8497642
Median Absolute Deviation (MAD)	0
Skewness	9.2150555
Sum	3478466
Variance	49.354474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	452522	50.1%
2	143770	15.9%
3	73835	8.2%
4	45192	5.0%
5	33411	3.7%
6	24688	2.7%
7	19476	2.2%
8	15272	1.7%
9	12585	1.4%
10	10104	1.1%
Other values (203)	72698	8.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	452522	50.1%
2	143770	15.9%
3	73835	8.2%
4	45192	5.0%
5	33411	3.7%
6	24688	2.7%
7	19476	2.2%
8	15272	1.7%
9	12585	1.4%
10	10104	1.1%

Value	Count	Frequency (%)
469	1	< 0.1%
466	1	< 0.1%
431	1	< 0.1%
429	1	< 0.1%
400	1	< 0.1%
358	1	< 0.1%
351	1	< 0.1%
343	1	< 0.1%
341	2	< 0.1%
340	1	< 0.1%

transactionRevenue
Real number (ℝ)

MISSING SKEWED

Distinct	5332
Distinct (%)	46.3%
Missing	892138
Missing (%)	98.7%
Infinite	0
Infinite (%)	0.0%
Mean	1.3374479 × 10⁸

Minimum	10000
Maximum	2.31295 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	10000
5-th percentile	10630000
Q1	24930000
median	49450000
Q3	1.07655 × 10⁸
95-th percentile	4.92576 × 10⁸
Maximum	2.31295 × 10¹⁰
Range	2.312949 × 10¹⁰
Interquartile range (IQR)	82725000

Descriptive statistics

Standard deviation	4.4828523 × 10⁸
Coefficient of variation (CV)	3.3517959
Kurtosis	1020.3068
Mean	1.3374479 × 10⁸
Median Absolute Deviation (MAD)	30470000
Skewness	25.722703
Sum	1.5400712 × 10¹²
Variance	2.0095965 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16990000	256	< 0.1%
18990000	189	< 0.1%
33590000	187	< 0.1%
44790000	170	< 0.1%
13590000	135	< 0.1%
55990000	122	< 0.1%
19990000	116	< 0.1%
15990000	98	< 0.1%
15190000	93	< 0.1%
19190000	92	< 0.1%
Other values (5322)	10057	1.1%
(Missing)	892138	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000	1	< 0.1%
40000	1	< 0.1%
90000	1	< 0.1%
160000	1	< 0.1%
200000	1	< 0.1%
490000	1	< 0.1%
770000	1	< 0.1%
790000	1	< 0.1%
990000	1	< 0.1%
1200000	7	< 0.1%

Value	Count	Frequency (%)
2.31295 × 10¹⁰	1	< 0.1%
1.78555 × 10¹⁰	1	< 0.1%
1.602375 × 10¹⁰	1	< 0.1%
1.058914 × 10¹⁰	1	< 0.1%
8677830000	1	< 0.1%
8248800000	1	< 0.1%
6996500000	1	< 0.1%
6826960000	1	< 0.1%
6248750000	1	< 0.1%
5614440000	1	< 0.1%

campaign
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

(not set)	865347
Data Share Promo	16403
AW - Dynamic Search Ads Whole Site	14244
AW - Accessories	7070
test-liyuhz	392
Other values (5)	197

Length

Max length	47
Median length	9
Mean length	9.5797779
Min length	9

Characters and Unicode

Total characters	8656795
Distinct characters	34
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	(not set)
2nd row	(not set)
3rd row	(not set)
4th row	(not set)
5th row	(not set)

Common Values

Value	Count	Frequency (%)
(not set)	865347	95.8%
Data Share Promo	16403	1.8%
AW - Dynamic Search Ads Whole Site	14244	1.6%
AW - Accessories	7070	0.8%
test-liyuhz	392	< 0.1%
AW - Electronics	96	< 0.1%
Retail (DO NOT EDIT owners nophakun and tianyu)	50	< 0.1%
AW - Apparel	46	< 0.1%
All Products	4	< 0.1%
Data Share	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	865397	45.5%
set	865347	45.5%
aw	21456	1.1%
	21456	1.1%
data	16404	0.9%
share	16404	0.9%
promo	16403	0.9%
dynamic	14244	0.7%
search	14244	0.7%
ads	14244	0.7%
Other values (15)	36450	1.9%

Most occurring characters

Value	Count	Frequency (%)
t	1762326	20.4%
	998396	11.5%
e	939257	10.8%
o	919667	10.6%
s	901343	10.4%
n	879937	10.2%
)	865397	10.0%
(	865397	10.0%
a	77946	0.9%
r	54317	0.6%
Other values (24)	392812	4.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5734694	66.2%
Space Separator	998396	11.5%
Close Punctuation	865397	10.0%
Open Punctuation	865397	10.0%
Uppercase Letter	171063	2.0%
Dash Punctuation	21848	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1762326	30.7%
e	939257	16.4%
o	919667	16.0%
s	901343	15.7%
n	879937	15.3%
a	77946	1.4%
r	54317	0.9%
h	45334	0.8%
c	42824	0.7%
i	36146	0.6%
Other values (9)	75597	1.3%

Uppercase Letter

Value	Count	Frequency (%)
S	44892	26.2%
A	42820	25.0%
W	35700	20.9%
D	30748	18.0%
P	16407	9.6%
E	146	0.1%
O	100	0.1%
T	100	0.1%
R	50	< 0.1%
N	50	< 0.1%

Space Separator

Value	Count	Frequency (%)
	998396	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	865397	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	865397	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	21848	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5905757	68.2%
Common	2751038	31.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1762326	29.8%
e	939257	15.9%
o	919667	15.6%
s	901343	15.3%
n	879937	14.9%
a	77946	1.3%
r	54317	0.9%
h	45334	0.8%
S	44892	0.8%
c	42824	0.7%
Other values (20)	237914	4.0%

Common

Value	Count	Frequency (%)
	998396	36.3%
)	865397	31.5%
(	865397	31.5%
-	21848	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8656795	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1762326	20.4%
	998396	11.5%
e	939257	10.8%
o	919667	10.6%
s	901343	10.4%
n	879937	10.2%
)	865397	10.0%
(	865397	10.0%
a	77946	0.9%
r	54317	0.6%
Other values (24)	392812	4.5%

source
Text

Distinct	380
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	56.9 MiB

Length

Max length	60
Median length	49
Mean length	9.0206938
Min length	3

Characters and Unicode

Total characters	8151577
Distinct characters	43
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	125 ?
Unique (%)	< 0.1%

Sample

1st row	google
2nd row	google
3rd row	google
4th row	google
5th row	google

Value	Count	Frequency (%)
google	400788	44.3%
youtube.com	212602	23.5%
direct	143028	15.8%
mall.googleplex.com	66416	7.3%
partners	16411	1.8%
analytics.google.com	16172	1.8%
dfa	5686	0.6%
google.com	4669	0.5%
m.facebook.com	3365	0.4%
baidu	3356	0.4%
Other values (371)	31229	3.5%

Most occurring characters

Value	Count	Frequency (%)
o	1571376	19.3%
g	1006376	12.3%
e	958629	11.8%
l	730101	9.0%
c	500801	6.1%
u	437502	5.4%
.	434839	5.3%
t	402952	4.9%
m	401095	4.9%
y	233355	2.9%
Other values (33)	1474551	18.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7412657	90.9%
Other Punctuation	434933	5.3%
Open Punctuation	143097	1.8%
Close Punctuation	143097	1.8%
Uppercase Letter	16411	0.2%
Decimal Number	971	< 0.1%
Dash Punctuation	342	< 0.1%
Space Separator	69	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1571376	21.2%
g	1006376	13.6%
e	958629	12.9%
l	730101	9.8%
c	500801	6.8%
u	437502	5.9%
t	402952	5.4%
m	401095	5.4%
y	233355	3.1%
b	228412	3.1%
Other values (16)	942058	12.7%

Decimal Number

Value	Count	Frequency (%)
0	305	31.4%
2	273	28.1%
8	132	13.6%
9	97	10.0%
3	39	4.0%
1	38	3.9%
5	31	3.2%
6	24	2.5%
4	20	2.1%
7	12	1.2%

Other Punctuation

Value	Count	Frequency (%)
.	434839	> 99.9%
:	94	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	143097	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	143097	100.0%

Uppercase Letter

Value	Count	Frequency (%)
P	16411	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	342	100.0%

Space Separator

Value	Count	Frequency (%)
	69	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7429068	91.1%
Common	722509	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1571376	21.2%
g	1006376	13.5%
e	958629	12.9%
l	730101	9.8%
c	500801	6.7%
u	437502	5.9%
t	402952	5.4%
m	401095	5.4%
y	233355	3.1%
b	228412	3.1%
Other values (17)	958469	12.9%

Common

Value	Count	Frequency (%)
.	434839	60.2%
(	143097	19.8%
)	143097	19.8%
-	342	< 0.1%
0	305	< 0.1%
2	273	< 0.1%
8	132	< 0.1%
9	97	< 0.1%
:	94	< 0.1%
	69	< 0.1%
Other values (6)	164	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8151577	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1571376	19.3%
g	1006376	12.3%
e	958629	11.8%
l	730101	9.0%
c	500801	6.1%
u	437502	5.4%
.	434839	5.3%
t	402952	4.9%
m	401095	4.9%
y	233355	2.9%
Other values (33)	1474551	18.1%

medium
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.2 MiB

organic	381561
referral	330955
(none)	143026
cpc	25326
affiliate	16403
Other values (2)	6382

Length

Max length	9
Median length	8
Mean length	7.1047117
Min length	3

Characters and Unicode

Total characters	6420194
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	organic
2nd row	organic
3rd row	organic
4th row	organic
5th row	organic

Common Values

Value	Count	Frequency (%)
organic	381561	42.2%
referral	330955	36.6%
(none)	143026	15.8%
cpc	25326	2.8%
affiliate	16403	1.8%
cpm	6262	0.7%
(not set)	120	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
organic	381561	42.2%
referral	330955	36.6%
none	143026	15.8%
cpc	25326	2.8%
affiliate	16403	1.8%
cpm	6262	0.7%
not	120	< 0.1%
set	120	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
r	1374426	21.4%
e	821459	12.8%
a	745322	11.6%
n	667733	10.4%
o	524707	8.2%
c	438475	6.8%
i	414367	6.5%
g	381561	5.9%
f	363761	5.7%
l	347358	5.4%
Other values (7)	341025	5.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6133782	95.5%
Open Punctuation	143146	2.2%
Close Punctuation	143146	2.2%
Space Separator	120	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1374426	22.4%
e	821459	13.4%
a	745322	12.2%
n	667733	10.9%
o	524707	8.6%
c	438475	7.1%
i	414367	6.8%
g	381561	6.2%
f	363761	5.9%
l	347358	5.7%
Other values (4)	54613	0.9%

Open Punctuation

Value	Count	Frequency (%)
(	143146	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	143146	100.0%

Space Separator

Value	Count	Frequency (%)
	120	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6133782	95.5%
Common	286412	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1374426	22.4%
e	821459	13.4%
a	745322	12.2%
n	667733	10.9%
o	524707	8.6%
c	438475	7.1%
i	414367	6.8%
g	381561	6.2%
f	363761	5.9%
l	347358	5.7%
Other values (4)	54613	0.9%

Common

Value	Count	Frequency (%)
(	143146	50.0%
)	143146	50.0%
	120	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6420194	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1374426	21.4%
e	821459	12.8%
a	745322	11.6%
n	667733	10.4%
o	524707	8.2%
c	438475	6.8%
i	414367	6.5%
g	381561	5.9%
f	363761	5.7%
l	347358	5.4%
Other values (7)	341025	5.3%

keyword
Text

MISSING

Distinct	3659
Distinct (%)	0.9%
Missing	502929
Missing (%)	55.7%
Memory size	42.6 MiB

Length

Max length	147
Median length	14
Mean length	14.332388
Min length	1

Characters and Unicode

Total characters	5743332
Distinct characters	295
Distinct categories	18 ?
Distinct scripts	13 ?
Distinct blocks	14 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2763 ?
Unique (%)	0.7%

Sample

1st row	(not provided)
2nd row	(not provided)
3rd row	(not provided)
4th row	google + online
5th row	(not provided)

Value	Count	Frequency (%)
not	366363	46.2%
provided	366363	46.2%
6qehscssdk0z36ri	11503	1.5%
google	10301	1.3%
merchandise	5671	0.7%
store	5316	0.7%
targeting	3086	0.4%
youtube	2833	0.4%
remarketing/content	2298	0.3%
1hzbaqlcbjwfgoh7	2264	0.3%
Other values (2422)	16694	2.1%

Most occurring characters

Value	Count	Frequency (%)
o	772784	13.5%
d	752095	13.1%
e	416576	7.3%
r	401124	7.0%
t	397351	6.9%
i	395175	6.9%
	391968	6.8%
n	386835	6.7%
(	369878	6.4%
)	369877	6.4%
Other values (285)	1089669	19.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4480669	78.0%
Space Separator	391968	6.8%
Open Punctuation	369878	6.4%
Close Punctuation	369877	6.4%
Uppercase Letter	66215	1.2%
Decimal Number	53129	0.9%
Other Punctuation	5413	0.1%
Math Symbol	4796	0.1%
Dash Punctuation	690	< 0.1%
Other Letter	496	< 0.1%
Other values (8)	201	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
网	38	7.7%
官	37	7.5%
商	34	6.9%
店	32	6.5%
ক	17	3.4%
র	16	3.2%
シ	13	2.6%
ツ	12	2.4%
ャ	12	2.4%
谷	11	2.2%
Other values (118)	274	55.2%

Lowercase Letter

Value	Count	Frequency (%)
o	772784	17.2%
d	752095	16.8%
e	416576	9.3%
r	401124	9.0%
t	397351	8.9%
i	395175	8.8%
n	386835	8.6%
p	368763	8.2%
v	367210	8.2%
s	52440	1.2%
Other values (71)	170316	3.8%

Uppercase Letter

Value	Count	Frequency (%)
C	16135	24.4%
K	12009	18.1%
E	11748	17.7%
G	3090	4.7%
M	2992	4.5%
Z	2732	4.1%
A	2494	3.8%
R	2472	3.7%
O	2455	3.7%
H	2376	3.6%
Other values (18)	7712	11.6%

Other Punctuation

Value	Count	Frequency (%)
/	3604	66.6%
.	1181	21.8%
:	332	6.1%
&	144	2.7%
?	43	0.8%
'	33	0.6%
*	26	0.5%
,	17	0.3%
"	15	0.3%
#	7	0.1%
Other values (4)	11	0.2%

Spacing Mark

Value	Count	Frequency (%)
া	29	44.6%
ে	14	21.5%
ি	8	12.3%
ा	3	4.6%
ী	3	4.6%
ো	2	3.1%
ो	2	3.1%
ॉ	1	1.5%
ੀ	1	1.5%
ी	1	1.5%

Decimal Number

Value	Count	Frequency (%)
6	23566	44.4%
0	12053	22.7%
3	11550	21.7%
1	2936	5.5%
7	2288	4.3%
4	507	1.0%
2	127	0.2%
5	53	0.1%
9	32	0.1%
8	17	< 0.1%

Nonspacing Mark

Value	Count	Frequency (%)
্	9	31.0%
ू	5	17.2%
्	5	17.2%
ূ	3	10.3%
ु	2	6.9%
े	2	6.9%
ँ	1	3.4%
ু	1	3.4%
ं	1	3.4%

Dash Punctuation

Value	Count	Frequency (%)
-	688	99.7%
–	1	0.1%
‑	1	0.1%

Math Symbol

Value	Count	Frequency (%)
+	4577	95.4%
=	219	4.6%

Space Separator

Value	Count	Frequency (%)
	391968	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	369878	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	369877	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	99	100.0%

Format

Value	Count	Frequency (%)
‏	3	100.0%

Modifier Letter

Value	Count	Frequency (%)
ー	2	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Modifier Symbol

Value	Count	Frequency (%)
¨	1	100.0%

Other Symbol

Value	Count	Frequency (%)
👉	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4546613	79.2%
Common	1195858	20.8%
Cyrillic	227	< 0.1%
Bengali	190	< 0.1%
Han	186	< 0.1%
Katakana	71	< 0.1%
Devanagari	69	< 0.1%
Arabic	50	< 0.1%
Greek	44	< 0.1%
Hangul	10	< 0.1%
Other values (3)	14	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	772784	17.0%
d	752095	16.5%
e	416576	9.2%
r	401124	8.8%
t	397351	8.7%
i	395175	8.7%
n	386835	8.5%
p	368763	8.1%
v	367210	8.1%
s	52440	1.2%
Other values (59)	236260	5.2%

Common

Value	Count	Frequency (%)
	391968	32.8%
(	369878	30.9%
)	369877	30.9%
6	23566	2.0%
0	12053	1.0%
3	11550	1.0%
+	4577	0.4%
/	3604	0.3%
1	2936	0.2%
7	2288	0.2%
Other values (28)	3561	0.3%

Bengali

Value	Count	Frequency (%)
া	29	15.3%
ক	17	8.9%
র	16	8.4%
ে	14	7.4%
প	9	4.7%
্	9	4.7%
ন	8	4.2%
ি	8	4.2%
ট	7	3.7%
ই	6	3.2%
Other values (25)	67	35.3%

Han

Value	Count	Frequency (%)
网	38	20.4%
官	37	19.9%
商	34	18.3%
店	32	17.2%
谷	11	5.9%
歌	10	5.4%
城	2	1.1%
镜	1	0.5%
件	1	0.5%
在	1	0.5%
Other values (19)	19	10.2%

Cyrillic

Value	Count	Frequency (%)
а	21	9.3%
о	20	8.8%
г	20	8.8%
т	19	8.4%
р	16	7.0%
н	16	7.0%
и	13	5.7%
у	13	5.7%
к	11	4.8%
е	11	4.8%
Other values (15)	67	29.5%

Devanagari

Value	Count	Frequency (%)
ट	7	10.1%
ग	7	10.1%
ू	5	7.2%
र	5	7.2%
्	5	7.2%
ल	4	5.8%
श	4	5.8%
स	4	5.8%
ा	3	4.3%
य	3	4.3%
Other values (15)	22	31.9%

Katakana

Value	Count	Frequency (%)
シ	13	18.3%
ツ	12	16.9%
ャ	12	16.9%
グ	5	7.0%
ン	5	7.0%
ッ	3	4.2%
イ	3	4.2%
ル	2	2.8%
ラ	2	2.8%
ア	2	2.8%
Other values (11)	12	16.9%

Arabic

Value	Count	Frequency (%)
و	11	22.0%
ي	10	20.0%
ت	7	14.0%
ب	6	12.0%
غ	2	4.0%
ل	2	4.0%
ج	2	4.0%
س	2	4.0%
ی	2	4.0%
ح	1	2.0%
Other values (5)	5	10.0%

Greek

Value	Count	Frequency (%)
ο	8	18.2%
λ	5	11.4%
α	5	11.4%
τ	5	11.4%
γ	3	6.8%
π	3	6.8%
υ	3	6.8%
ι	3	6.8%
ε	3	6.8%
η	1	2.3%
Other values (5)	5	11.4%

Hangul

Value	Count	Frequency (%)
셔	1	10.0%
ㅕ	1	10.0%
ㅠ	1	10.0%
채	1	10.0%
ㅡ	1	10.0%
글	1	10.0%
구	1	10.0%
ㄷ	1	10.0%
ㅛ	1	10.0%
ㅐ	1	10.0%

Hebrew

Value	Count	Frequency (%)
ס	2	28.6%
ק	1	14.3%
י	1	14.3%
ר	1	14.3%
ת	1	14.3%
א	1	14.3%

Hiragana

Value	Count	Frequency (%)
を	1	25.0%
る	1	25.0%
す	1	25.0%
の	1	25.0%

Gurmukhi

Value	Count	Frequency (%)
ਠ	1	33.3%
ੀ	1	33.3%
ਢ	1	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5742438	> 99.9%
Cyrillic	227	< 0.1%
Bengali	190	< 0.1%
CJK	186	< 0.1%
Katakana	73	< 0.1%
None	70	< 0.1%
Devanagari	69	< 0.1%
Arabic	50	< 0.1%
Hebrew	7	< 0.1%
Compat Jamo	6	< 0.1%
Other values (4)	16	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	772784	13.5%
d	752095	13.1%
e	416576	7.3%
r	401124	7.0%
t	397351	6.9%
i	395175	6.9%
	391968	6.8%
n	386835	6.7%
(	369878	6.4%
)	369877	6.4%
Other values (74)	1088775	19.0%

CJK

Value	Count	Frequency (%)
网	38	20.4%
官	37	19.9%
商	34	18.3%
店	32	17.2%
谷	11	5.9%
歌	10	5.4%
城	2	1.1%
镜	1	0.5%
件	1	0.5%
在	1	0.5%
Other values (19)	19	10.2%

Bengali

Value	Count	Frequency (%)
া	29	15.3%
ক	17	8.9%
র	16	8.4%
ে	14	7.4%
প	9	4.7%
্	9	4.7%
ন	8	4.2%
ি	8	4.2%
ট	7	3.7%
ই	6	3.2%
Other values (25)	67	35.3%

Cyrillic

Value	Count	Frequency (%)
а	21	9.3%
о	20	8.8%
г	20	8.8%
т	19	8.4%
р	16	7.0%
н	16	7.0%
и	13	5.7%
у	13	5.7%
к	11	4.8%
е	11	4.8%
Other values (15)	67	29.5%

Katakana

Value	Count	Frequency (%)
シ	13	17.8%
ツ	12	16.4%
ャ	12	16.4%
グ	5	6.8%
ン	5	6.8%
ッ	3	4.1%
イ	3	4.1%
ー	2	2.7%
ル	2	2.7%
ラ	2	2.7%
Other values (12)	14	19.2%

Arabic

Value	Count	Frequency (%)
و	11	22.0%
ي	10	20.0%
ت	7	14.0%
ب	6	12.0%
غ	2	4.0%
ل	2	4.0%
ج	2	4.0%
س	2	4.0%
ی	2	4.0%
ح	1	2.0%
Other values (5)	5	10.0%

None

Value	Count	Frequency (%)
ο	8	11.4%
ñ	7	10.0%
λ	5	7.1%
α	5	7.1%
τ	5	7.1%
γ	3	4.3%
π	3	4.3%
υ	3	4.3%
ι	3	4.3%
ε	3	4.3%
Other values (24)	25	35.7%

Devanagari

Value	Count	Frequency (%)
ट	7	10.1%
ग	7	10.1%
ू	5	7.2%
र	5	7.2%
्	5	7.2%
ल	4	5.8%
श	4	5.8%
स	4	5.8%
ा	3	4.3%
य	3	4.3%
Other values (15)	22	31.9%

Punctuation

Value	Count	Frequency (%)
‏	3	60.0%
–	1	20.0%
‑	1	20.0%

Hebrew

Value	Count	Frequency (%)
ס	2	28.6%
ק	1	14.3%
י	1	14.3%
ר	1	14.3%
ת	1	14.3%
א	1	14.3%

Hangul

Value	Count	Frequency (%)
셔	1	25.0%
채	1	25.0%
글	1	25.0%
구	1	25.0%

Compat Jamo

Value	Count	Frequency (%)
ㅕ	1	16.7%
ㅠ	1	16.7%
ㅡ	1	16.7%
ㄷ	1	16.7%
ㅛ	1	16.7%
ㅐ	1	16.7%

Gurmukhi

Value	Count	Frequency (%)
ਠ	1	33.3%
ੀ	1	33.3%
ਢ	1	33.3%

Hiragana

Value	Count	Frequency (%)
を	1	25.0%
る	1	25.0%
す	1	25.0%
の	1	25.0%

referralPath
Path

MISSING

Distinct	1475
Distinct (%)	0.4%
Missing	572712
Missing (%)	63.4%
Memory size	39.5 MiB

/	75523
/yt/about/	71036
/analytics/web/	14620
/yt/about/tr/	14599
/yt/about/vi/	13753
Other values (1470)	141410

Length

Max length	270
Median length	227
Mean length	12.654307
Min length	1

Characters and Unicode

Total characters	4187829
Distinct characters	80
Distinct categories	8 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	616 ?
Unique (%)	0.2%

Sample

1st row	/
2nd row	/
3rd row	/corp/google.com/study/incentives/working-with-perks
4th row	/od/Things-To-Do-in-Silicon-Valley/fl/How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm
5th row	/od/Things-To-Do-in-Silicon-Valley/fl/How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm

Common Values

Value	Count	Frequency (%)
/	75523	8.4%
/yt/about/	71036	7.9%
/analytics/web/	14620	1.6%
/yt/about/tr/	14599	1.6%
/yt/about/vi/	13753	1.5%
/yt/about/es-419/	12735	1.4%
/yt/about/pt-BR/	12003	1.3%
/yt/about/th/	11430	1.3%
/yt/about/ru/	11193	1.2%
/yt/about/es/	7092	0.8%
Other values (1465)	86957	9.6%
(Missing)	572712	63.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	75523	22.8%
yt/about	71036	21.5%
analytics/web	14620	4.4%
yt/about/tr	14599	4.4%
yt/about/vi	13753	4.2%
yt/about/es-419	12735	3.8%
yt/about/pt-br	12003	3.6%
yt/about/th	11430	3.5%
yt/about/ru	11193	3.4%
yt/about/es	7092	2.1%
Other values (1455)	86957	26.3%

Most occurring characters

Value	Count	Frequency (%)
/	986276	23.6%
t	539889	12.9%
o	313010	7.5%
a	299566	7.2%
u	248905	5.9%
b	239785	5.7%
y	235075	5.6%
e	137264	3.3%
-	116586	2.8%
i	108143	2.6%
Other values (70)	963330	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2837830	67.8%
Other Punctuation	1002859	23.9%
Dash Punctuation	116586	2.8%
Uppercase Letter	113210	2.7%
Decimal Number	96366	2.3%
Connector Punctuation	19108	0.5%
Math Symbol	1862	< 0.1%
Other Letter	8	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	539889	19.0%
o	313010	11.0%
a	299566	10.6%
u	248905	8.8%
b	239785	8.4%
y	235075	8.3%
e	137264	4.8%
i	108143	3.8%
s	101202	3.6%
n	87445	3.1%
Other values (16)	527546	18.6%

Uppercase Letter

Value	Count	Frequency (%)
B	20815	18.4%
G	13512	11.9%
R	13108	11.6%
T	10994	9.7%
V	6806	6.0%
H	5551	4.9%
W	4236	3.7%
I	4028	3.6%
D	3622	3.2%
M	3051	2.7%
Other values (16)	27487	24.3%

Decimal Number

Value	Count	Frequency (%)
1	25651	26.6%
4	19573	20.3%
9	19453	20.2%
0	8132	8.4%
7	5765	6.0%
2	5212	5.4%
6	4462	4.6%
5	3207	3.3%
3	2764	2.9%
8	2147	2.2%

Other Letter

Value	Count	Frequency (%)
س	2	25.0%
ف	1	12.5%
ي	1	12.5%
ل	1	12.5%
م	1	12.5%
ك	1	12.5%
ى	1	12.5%

Other Punctuation

Value	Count	Frequency (%)
/	986276	98.3%
.	15578	1.6%
%	836	0.1%
,	124	< 0.1%
:	44	< 0.1%
@	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
=	1829	98.2%
+	32	1.7%
~	1	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	116586	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	19108	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2951040	70.5%
Common	1236781	29.5%
Arabic	8	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	539889	18.3%
o	313010	10.6%
a	299566	10.2%
u	248905	8.4%
b	239785	8.1%
y	235075	8.0%
e	137264	4.7%
i	108143	3.7%
s	101202	3.4%
n	87445	3.0%
Other values (42)	640756	21.7%

Common

Value	Count	Frequency (%)
/	986276	79.7%
-	116586	9.4%
1	25651	2.1%
4	19573	1.6%
9	19453	1.6%
_	19108	1.5%
.	15578	1.3%
0	8132	0.7%
7	5765	0.5%
2	5212	0.4%
Other values (11)	15447	1.2%

Arabic

Value	Count	Frequency (%)
س	2	25.0%
ف	1	12.5%
ي	1	12.5%
ل	1	12.5%
م	1	12.5%
ك	1	12.5%
ى	1	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4187821	> 99.9%
Arabic	8	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	986276	23.6%
t	539889	12.9%
o	313010	7.5%
a	299566	7.2%
u	248905	5.9%
b	239785	5.7%
y	235075	5.6%
e	137264	3.3%
-	116586	2.8%
i	108143	2.6%
Other values (63)	963322	23.0%

Arabic

Value	Count	Frequency (%)
س	2	25.0%
ف	1	12.5%
ي	1	12.5%
ل	1	12.5%
م	1	12.5%
ك	1	12.5%
ى	1	12.5%

Common prefix	/
Unique stems	1474
Unique names	515
Unique extensions	23
Unique directories	1124
Unique anchors	1

Value	Count	Frequency (%)
/	75523	8.4%
/yt/about/	71036	7.9%
/analytics/web/	14620	1.6%
/yt/about/tr/	14599	1.6%
/yt/about/vi/	13753	1.5%
/yt/about/es-419/	12735	1.4%
/yt/about/pt-BR/	12003	1.3%
/yt/about/th/	11430	1.3%
/yt/about/ru/	11193	1.2%
/yt/about/es/	7092	0.8%
Other values (1465)	86957	9.6%
(Missing)	572712	63.4%

Value	Count	Frequency (%)
/	75523	8.4%
/yt/about/	71036	7.9%
/analytics/web/	14620	1.6%
/yt/about/tr/	14599	1.6%
/yt/about/vi/	13753	1.5%
/yt/about/es-419/	12735	1.4%
/yt/about/pt-BR/	12003	1.3%
/yt/about/th/	11430	1.3%
/yt/about/ru/	11193	1.2%
/yt/about/es/	7092	0.8%
Other values (1464)	86957	9.6%
(Missing)	572712	63.4%

Value	Count	Frequency (%)
	304574	33.7%
using-the-logo.html	5284	0.6%
How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm	2056	0.2%
index.html	2023	0.2%
c10b14f9a69ff71b1b7a	1784	0.2%
inpage_launch	1638	0.2%
alphabet-google-discounts	1118	0.1%
2145	1064	0.1%
Where-can-I-buy-a-stuffed-Go-language-gopher-mascot-online	872	0.1%
mobile	812	0.1%
Other values (505)	9716	1.1%
(Missing)	572712	63.4%

Value	Count	Frequency (%)
	319771	35.4%
.html	7848	0.9%
.htm	2059	0.2%
.php	724	0.1%
.aspx	190	< 0.1%
.jhtml	145	< 0.1%
.jspa	80	< 0.1%
.jsp	73	< 0.1%
.pdf	15	< 0.1%
.lai	8	< 0.1%
Other values (13)	28	< 0.1%
(Missing)	572712	63.4%

Value	Count	Frequency (%)
/	82812	9.2%
/yt/about	71408	7.9%
/analytics/web	16258	1.8%
/yt/about/tr	14665	1.6%
/yt/about/vi	13788	1.5%
/yt/about/es-419	12832	1.4%
/yt/about/pt-BR	12077	1.3%
/yt/about/th	11471	1.3%
/yt/about/ru	11294	1.2%
/yt/about/es	7143	0.8%
Other values (1114)	77193	8.5%
(Missing)	572712	63.4%

Value	Count	Frequency (%)
	330941	36.6%
(Missing)	572712	63.4%

adwordsClickInfo.page
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	8
Distinct (%)	< 0.1%
Missing	882193
Missing (%)	97.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.0081081

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	14
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.17358392
Coefficient of variation (CV)	0.1721878
Kurtosis	2188.361
Mean	1.0081081
Median Absolute Deviation (MAD)	0
Skewness	40.170902
Sum	21634
Variance	0.030131376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	21362	2.4%
2	73	< 0.1%
3	10	< 0.1%
5	7	< 0.1%
7	3	< 0.1%
9	2	< 0.1%
4	2	< 0.1%
14	1	< 0.1%
(Missing)	882193	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	21362	2.4%
2	73	< 0.1%
3	10	< 0.1%
4	2	< 0.1%
5	7	< 0.1%
7	3	< 0.1%
9	2	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
9	2	< 0.1%
7	3	< 0.1%
5	7	< 0.1%
4	2	< 0.1%
3	10	< 0.1%
2	73	< 0.1%
1	21362	2.4%

adwordsClickInfo.slot
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	882193
Missing (%)	97.6%
Memory size	34.9 MiB

Top	20956
RHS	504

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	64380
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Top
2nd row	Top
3rd row	Top
4th row	Top
5th row	Top

Common Values

Value	Count	Frequency (%)
Top	20956	2.3%
RHS	504	0.1%
(Missing)	882193	97.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
top	20956	97.7%
rhs	504	2.3%

Most occurring characters

Value	Count	Frequency (%)
T	20956	32.6%
o	20956	32.6%
p	20956	32.6%
R	504	0.8%
H	504	0.8%
S	504	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	41912	65.1%
Uppercase Letter	22468	34.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	20956	93.3%
R	504	2.2%
H	504	2.2%
S	504	2.2%

Lowercase Letter

Value	Count	Frequency (%)
o	20956	50.0%
p	20956	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	64380	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	20956	32.6%
o	20956	32.6%
p	20956	32.6%
R	504	0.8%
H	504	0.8%
S	504	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64380	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	20956	32.6%
o	20956	32.6%
p	20956	32.6%
R	504	0.8%
H	504	0.8%
S	504	0.8%

adwordsClickInfo.gclId
Text

MISSING

Distinct	17774
Distinct (%)	82.4%
Missing	882092
Missing (%)	97.6%
Memory size	29.5 MiB

Length

Max length	92
Median length	91
Mean length	69.235703
Min length	26

Characters and Unicode

Total characters	1492791
Distinct characters	64
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15688 ?
Unique (%)	72.8%

Sample

1st row	Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRBVDYwnFawcmsrhs02pjO7FXPLhzHyvJFv53h1H4QJ8aAhtw8P8HAQ
2nd row	Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRAq0D2zir1iAiqwgFU0lcMGVY6qaqhBTOFSAIW7gM8saAiku8P8HAQ
3rd row	Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRMbhgNCALey5pPeCxitqlWsaKLtXW_EC8qRLRreq6OMaApJJ8P8HAQ
4th row	Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRBRI7rtb79aCyB-UUNNHh1V712wows-T-MlL9VW-8ZEaAhqd8P8HAQ
5th row	Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRDKcQOTkfRji3NxEErk_rDSPqc8VzHFSZnRcZBCoBOgaAgeG8P8HAQ

Value	Count	Frequency (%)
cj0keqjwmirjbrcrmj_x7kdo-9obeiqauupkmufmpug3zdwyo8gtsjibfd5mphstza9y_9ncri8x97oaaglc8p8haq	70	0.3%
cj0keqjw1ee_brd3hk6x993yzeobeiqa5rh_bea562m9tvl_mtnafvtdndqoqrp1rvxmmgwjcx1lafwaaj4o8p8haq	41	0.2%
cjh1vbf94m8cfuelgqodyakhgq	29	0.1%
cj0keqiaw_debrchnyiq_562gsebeiqa4lcssmb_rwgvppnltzlzj5rgwqx5lk87wc5cjfcqznenzewaaiap8p8haq	27	0.1%
cjwkeaiaj7tcbrcp2z22ue-zrj4sjacg7sbejui6ggr6oca-edc2-lx7w1m5ia1c_qnbzwzvtquanxocb5rw_wcb	24	0.1%
cn_u9pavhdacfcnahgodtcqajw	22	0.1%
cjwkeaiaxkrfbrdm25f60oegtwwsjabgec-z0_dlpcxhm1ztqlr1ywewxu875yaqwupt7pgmgfezthoceezw_wcb	21	0.1%
cnhp7nf2ytmcfvlwdqod_iol5a	20	0.1%
cjwkeaiavs7cbrc24rao6bgcoiasjabact5dtalfxcossvr2e2aduhx6z6oe0kauvtqkzl-bcvn1-hocnlrw_wcb	20	0.1%
cj6xtee6j9acfqqdfgod8tkdnw	18	0.1%
Other values (17764)	21269	98.6%

Most occurring characters

Value	Count	Frequency (%)
A	71957	4.8%
C	62703	4.2%
w	52857	3.5%
B	47608	3.2%
E	42671	2.9%
Q	42294	2.8%
j	40337	2.7%
K	32775	2.2%
o	31969	2.1%
R	30844	2.1%
Other values (54)	1036776	69.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	686721	46.0%
Lowercase Letter	564972	37.8%
Decimal Number	193611	13.0%
Connector Punctuation	28864	1.9%
Dash Punctuation	18623	1.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	71957	10.5%
C	62703	9.1%
B	47608	6.9%
E	42671	6.2%
Q	42294	6.2%
K	32775	4.8%
R	30844	4.5%
D	26904	3.9%
I	24996	3.6%
P	23785	3.5%
Other values (16)	280184	40.8%

Lowercase Letter

Value	Count	Frequency (%)
w	52857	9.4%
j	40337	7.1%
o	31969	5.7%
i	28639	5.1%
a	24959	4.4%
c	24188	4.3%
g	24027	4.3%
d	21898	3.9%
s	20665	3.7%
h	20152	3.6%
Other values (16)	275281	48.7%

Decimal Number

Value	Count	Frequency (%)
8	30621	15.8%
0	24046	12.4%
9	18500	9.6%
4	18386	9.5%
7	18118	9.4%
6	17972	9.3%
3	17049	8.8%
2	16457	8.5%
5	16391	8.5%
1	16071	8.3%

Connector Punctuation

Value	Count	Frequency (%)
_	28864	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	18623	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1251693	83.8%
Common	241098	16.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	71957	5.7%
C	62703	5.0%
w	52857	4.2%
B	47608	3.8%
E	42671	3.4%
Q	42294	3.4%
j	40337	3.2%
K	32775	2.6%
o	31969	2.6%
R	30844	2.5%
Other values (42)	795678	63.6%

Common

Value	Count	Frequency (%)
8	30621	12.7%
_	28864	12.0%
0	24046	10.0%
-	18623	7.7%
9	18500	7.7%
4	18386	7.6%
7	18118	7.5%
6	17972	7.5%
3	17049	7.1%
2	16457	6.8%
Other values (2)	32462	13.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1492791	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	71957	4.8%
C	62703	4.2%
w	52857	3.5%
B	47608	3.2%
E	42671	2.9%
Q	42294	2.8%
j	40337	2.7%
K	32775	2.2%
o	31969	2.1%
R	30844	2.1%
Other values (54)	1036776	69.5%

adwordsClickInfo.adNetworkType
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	882193
Missing (%)	97.6%
Memory size	35.1 MiB

Google Search	21453
Search partners	7

Length

Max length	15
Median length	13
Mean length	13.000652
Min length	13

Characters and Unicode

Total characters	278994
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Google Search
2nd row	Google Search
3rd row	Google Search
4th row	Google Search
5th row	Google Search

Common Values

Value	Count	Frequency (%)
Google Search	21453	2.4%
Search partners	7	< 0.1%
(Missing)	882193	97.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
search	21460	50.0%
google	21453	50.0%
partners	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	42920	15.4%
o	42906	15.4%
r	21474	7.7%
a	21467	7.7%
	21460	7.7%
S	21460	7.7%
c	21460	7.7%
h	21460	7.7%
G	21453	7.7%
g	21453	7.7%
Other values (5)	21481	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	214621	76.9%
Uppercase Letter	42913	15.4%
Space Separator	21460	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	42920	20.0%
o	42906	20.0%
r	21474	10.0%
a	21467	10.0%
c	21460	10.0%
h	21460	10.0%
g	21453	10.0%
l	21453	10.0%
p	7	< 0.1%
t	7	< 0.1%
Other values (2)	14	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
S	21460	50.0%
G	21453	50.0%

Space Separator

Value	Count	Frequency (%)
	21460	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	257534	92.3%
Common	21460	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	42920	16.7%
o	42906	16.7%
r	21474	8.3%
a	21467	8.3%
S	21460	8.3%
c	21460	8.3%
h	21460	8.3%
G	21453	8.3%
g	21453	8.3%
l	21453	8.3%
Other values (4)	28	< 0.1%

Common

Value	Count	Frequency (%)
	21460	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	278994	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	42920	15.4%
o	42906	15.4%
r	21474	7.7%
a	21467	7.7%
	21460	7.7%
S	21460	7.7%
c	21460	7.7%
h	21460	7.7%
G	21453	7.7%
g	21453	7.7%
Other values (5)	21481	7.7%

adContent
Categorical

HIGH CORRELATION MISSING

Distinct	44
Distinct (%)	0.4%
Missing	892707
Missing (%)	98.8%
Memory size	34.9 MiB

Google Merchandise Collection	5122
Google Online Store	1245
Display Ad created 3/11/14	967
Full auto ad IMAGE ONLY	822
Ad from 12/13/16	610
Other values (39)	2180

Length

Max length	43
Median length	34
Mean length	25.126622
Min length	8

Characters and Unicode

Total characters	275036
Distinct characters	63
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Full auto ad IMAGE ONLY
2nd row	First Full Auto Template Test Ad
3rd row	{KeyWord:Google Brand Items}
4th row	Full auto ad IMAGE ONLY
5th row	Full auto ad IMAGE ONLY

Common Values

Value	Count	Frequency (%)
Google Merchandise Collection	5122	0.6%
Google Online Store	1245	0.1%
Display Ad created 3/11/14	967	0.1%
Full auto ad IMAGE ONLY	822	0.1%
Ad from 12/13/16	610	0.1%
Ad from 11/3/16	489	0.1%
Display Ad created 3/11/15	392	< 0.1%
{KeyWord:Google Brand Items}	251	< 0.1%
{KeyWord:Google Merchandise}	155	< 0.1%
Ad from 11/7/16	123	< 0.1%
Other values (34)	770	0.1%
(Missing)	892707	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
google	6657	18.6%
merchandise	5368	15.0%
collection	5122	14.3%
ad	3572	10.0%
display	1409	3.9%
created	1409	3.9%
store	1252	3.5%
online	1245	3.5%
from	1225	3.4%
3/11/14	967	2.7%
Other values (60)	7620	21.3%

Most occurring characters

Value	Count	Frequency (%)
e	29938	10.9%
o	29217	10.6%
	24900	9.1%
l	22124	8.0%
n	13612	4.9%
i	13600	4.9%
c	12045	4.4%
d	11551	4.2%
a	10739	3.9%
r	10693	3.9%
Other values (53)	96617	35.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	192416	70.0%
Uppercase Letter	35962	13.1%
Space Separator	24900	9.1%
Decimal Number	14087	5.1%
Other Punctuation	6172	2.2%
Open Punctuation	677	0.2%
Close Punctuation	677	0.2%
Connector Punctuation	110	< 0.1%
Dash Punctuation	35	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29938	15.6%
o	29217	15.2%
l	22124	11.5%
n	13612	7.1%
i	13600	7.1%
c	12045	6.3%
d	11551	6.0%
a	10739	5.6%
r	10693	5.6%
t	9533	5.0%
Other values (12)	29364	15.3%

Uppercase Letter

Value	Count	Frequency (%)
G	8112	22.6%
M	6221	17.3%
C	5126	14.3%
A	3652	10.2%
O	2096	5.8%
D	1482	4.1%
S	1400	3.9%
I	1083	3.0%
F	1031	2.9%
L	996	2.8%
Other values (12)	4763	13.2%

Decimal Number

Value	Count	Frequency (%)
1	8015	56.9%
3	2458	17.4%
6	1222	8.7%
4	1017	7.2%
2	688	4.9%
5	433	3.1%
7	179	1.3%
0	75	0.5%

Other Punctuation

Value	Count	Frequency (%)
/	5276	85.5%
:	677	11.0%
?	111	1.8%
%	75	1.2%
'	31	0.5%
!	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	24900	100.0%

Open Punctuation

Value	Count	Frequency (%)
{	677	100.0%

Close Punctuation

Value	Count	Frequency (%)
}	677	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	110	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	228378	83.0%
Common	46658	17.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29938	13.1%
o	29217	12.8%
l	22124	9.7%
n	13612	6.0%
i	13600	6.0%
c	12045	5.3%
d	11551	5.1%
a	10739	4.7%
r	10693	4.7%
t	9533	4.2%
Other values (34)	65326	28.6%

Common

Value	Count	Frequency (%)
	24900	53.4%
1	8015	17.2%
/	5276	11.3%
3	2458	5.3%
6	1222	2.6%
4	1017	2.2%
2	688	1.5%
{	677	1.5%
:	677	1.5%
}	677	1.5%
Other values (9)	1051	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	275036	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	29938	10.9%
o	29217	10.6%
	24900	9.1%
l	22124	8.0%
n	13612	4.9%
i	13600	4.9%
c	12045	4.4%
d	11551	4.2%
a	10739	3.9%
r	10693	3.9%
Other values (53)	96617	35.1%

conversion
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	50.0 MiB

0	892138
1	11515

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	903653
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Most occurring characters

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	903653	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	903653	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	903653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	892138	98.7%
1	11515	1.3%

Auto

Heatmap
Table

	adContent	adwordsClickInfo.adNetworkType	adwordsClickInfo.page	adwordsClickInfo.slot	campaign	channelGrouping	continent	conversion	deviceCategory	hits	isMobile	medium	operatingSystem	pageviews	subContinent	transactionRevenue	visitId	visitNumber	visitStartTime
adContent	1.000	0.431	0.076	0.330	0.979	0.998	0.327	0.076	0.262	0.173	0.321	0.998	0.174	0.181	0.201	-0.127	0.559	-0.298	0.559
adwordsClickInfo.adNetworkType	0.431	1.000	-0.001	0.108	0.336	1.000	0.000	0.000	0.000	-0.021	0.000	1.000	0.000	-0.021	0.000	NaN	-0.007	0.002	-0.007
adwordsClickInfo.page	0.076	-0.001	1.000	0.186	0.005	1.000	0.000	0.000	0.004	-0.032	0.013	1.000	0.000	-0.032	0.000	NaN	-0.003	-0.008	-0.003
adwordsClickInfo.slot	0.330	0.108	0.186	1.000	0.098	1.000	0.013	0.009	0.109	0.082	0.059	1.000	0.070	0.084	0.000	0.005	0.015	0.045	0.015
campaign	0.979	0.336	0.005	0.098	1.000	0.516	0.069	0.019	0.068	0.041	0.094	0.557	0.039	0.041	0.060	-0.041	0.030	0.034	0.030
channelGrouping	0.998	1.000	1.000	1.000	0.516	1.000	0.188	0.131	0.218	-0.113	0.307	1.000	0.169	-0.111	0.222	0.031	-0.226	-0.088	-0.226
continent	0.327	0.000	0.000	0.013	0.069	0.188	1.000	0.109	0.063	-0.226	0.069	0.131	0.157	-0.227	1.000	0.002	-0.011	-0.165	-0.011
conversion	0.076	0.000	0.000	0.009	0.019	0.131	0.109	1.000	0.045	0.196	0.045	0.035	0.089	0.199	0.123	NaN	0.011	0.109	0.011
deviceCategory	0.262	0.000	0.004	0.109	0.068	0.218	0.063	0.045	1.000	-0.015	0.999	0.216	0.715	-0.017	0.129	-0.176	0.144	-0.028	0.144
hits	0.173	-0.021	-0.032	0.082	0.041	-0.113	-0.226	0.196	-0.015	1.000	0.024	0.007	0.016	0.992	0.022	0.295	-0.000	0.115	-0.000
isMobile	0.321	0.000	0.013	0.059	0.094	0.307	0.069	0.045	0.999	0.024	1.000	0.304	0.994	-0.018	0.167	-0.176	0.146	-0.029	0.146
medium	0.998	1.000	1.000	1.000	0.557	1.000	0.131	0.035	0.216	0.007	0.304	1.000	0.145	-0.072	0.169	0.034	-0.198	-0.053	-0.198
operatingSystem	0.174	0.000	0.000	0.070	0.039	0.169	0.157	0.089	0.715	0.016	0.994	0.145	1.000	-0.068	0.116	-0.067	0.001	-0.074	0.001
pageviews	0.181	-0.021	-0.032	0.084	0.041	-0.111	-0.227	0.199	-0.017	0.992	-0.018	-0.072	-0.068	1.000	0.016	0.270	0.005	0.114	0.005
subContinent	0.201	0.000	0.000	0.000	0.060	0.222	1.000	0.123	0.129	0.022	0.167	0.169	0.116	0.016	1.000	0.027	-0.047	-0.110	-0.047
transactionRevenue	-0.127	NaN	NaN	0.005	-0.041	0.031	0.002	NaN	-0.176	0.295	-0.176	0.034	-0.067	0.270	0.027	1.000	-0.069	0.218	-0.069
visitId	0.559	-0.007	-0.003	0.015	0.030	-0.226	-0.011	0.011	0.144	-0.000	0.146	-0.198	0.001	0.005	-0.047	-0.069	1.000	0.041	1.000
visitNumber	-0.298	0.002	-0.008	0.045	0.034	-0.088	-0.165	0.109	-0.028	0.115	-0.029	-0.053	-0.074	0.114	-0.110	0.218	0.041	1.000	0.041
visitStartTime	0.559	-0.007	-0.003	0.015	0.030	-0.226	-0.011	0.011	0.144	-0.000	0.146	-0.198	0.001	0.005	-0.047	-0.069	1.000	0.041	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	channelGrouping	date	fullVisitorId	sessionId	visitId	visitNumber	visitStartTime	continent	subContinent	country	region	metro	city	networkDomain	browser	operatingSystem	isMobile	deviceCategory	hits	pageviews	transactionRevenue	campaign	source	medium	keyword	referralPath	adwordsClickInfo.page	adwordsClickInfo.slot	adwordsClickInfo.gclId	adwordsClickInfo.adNetworkType	adContent
0	Organic Search	1970-01-01 00:00:00.020160902	1131660440785968503	1131660440785968503_1472830385	1472830385	1	1472830385	Asia	Western Asia	Turkey	Izmir	(not set)	Izmir	ttnet.com.tr	Chrome	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
1	Organic Search	1970-01-01 00:00:00.020160902	377306020877927890	377306020877927890_1472880147	1472880147	1	1472880147	Oceania	Australasia	Australia	not available in demo dataset	not available in demo dataset	not available in demo dataset	dodo.net.au	Firefox	Macintosh	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
2	Organic Search	1970-01-01 00:00:00.020160902	3895546263509774583	3895546263509774583_1472865386	1472865386	1	1472865386	Europe	Southern Europe	Spain	Community of Madrid	(not set)	Madrid	unknown.unknown	Chrome	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
3	Organic Search	1970-01-01 00:00:00.020160902	4763447161404445595	4763447161404445595_1472881213	1472881213	1	1472881213	Asia	Southeast Asia	Indonesia	not available in demo dataset	not available in demo dataset	not available in demo dataset	unknown.unknown	UC Browser	Linux	False	desktop	1	1.0	NaN	(not set)	google	organic	google + online	NaN	NaN	NaN	NaN	NaN	NaN
4	Organic Search	1970-01-01 00:00:00.020160902	27294437909732085	27294437909732085_1472822600	1472822600	2	1472822600	Europe	Northern Europe	United Kingdom	not available in demo dataset	not available in demo dataset	not available in demo dataset	unknown.unknown	Chrome	Android	True	mobile	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
5	Organic Search	1970-01-01 00:00:00.020160902	2938943183656635653	2938943183656635653_1472807194	1472807194	1	1472807194	Europe	Southern Europe	Italy	not available in demo dataset	not available in demo dataset	not available in demo dataset	fastwebnet.it	Chrome	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
6	Organic Search	1970-01-01 00:00:00.020160902	1905672039242460897	1905672039242460897_1472817241	1472817241	1	1472817241	Asia	Southern Asia	Pakistan	not available in demo dataset	not available in demo dataset	not available in demo dataset	unknown.unknown	Chrome	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
7	Organic Search	1970-01-01 00:00:00.020160902	537222803633850821	537222803633850821_1472812602	1472812602	1	1472812602	Oceania	Australasia	Australia	Queensland	(not set)	Brisbane	bigpond.net.au	Chrome	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
8	Organic Search	1970-01-01 00:00:00.020160902	4445454811831400414	4445454811831400414_1472805784	1472805784	1	1472805784	Europe	Western Europe	Austria	not available in demo dataset	not available in demo dataset	not available in demo dataset	spar.at	Internet Explorer	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN
9	Organic Search	1970-01-01 00:00:00.020160902	9499785259412240342	9499785259412240342_1472812272	1472812272	1	1472812272	Europe	Western Europe	Netherlands	not available in demo dataset	not available in demo dataset	not available in demo dataset	chello.nl	Firefox	Windows	False	desktop	1	1.0	NaN	(not set)	google	organic	(not provided)	NaN	NaN	NaN	NaN	NaN	NaN

	channelGrouping	date	fullVisitorId	sessionId	visitId	visitNumber	visitStartTime	continent	subContinent	country	region	metro	city	networkDomain	browser	operatingSystem	isMobile	deviceCategory	hits	pageviews	transactionRevenue	campaign	source	medium	keyword	referralPath	adwordsClickInfo.page	adwordsClickInfo.slot	adwordsClickInfo.gclId	adwordsClickInfo.adNetworkType	adContent
903643	Social	1970-01-01 00:00:00.020170104	56144239667131330	056144239667131330_1483600246	1483600246	4	1483600246	Americas	Northern America	United States	California	San Francisco-Oakland-San Jose CA	Fremont	(not set)	Chrome	Macintosh	False	desktop	11	10.0	NaN	(not set)	groups.google.com	referral	NaN	/a/google.com/forum/	NaN	NaN	NaN	NaN	NaN
903644	Social	1970-01-01 00:00:00.020170104	256641390199759052	256641390199759052_1483556333	1483556333	1	1483556333	Americas	Northern America	United States	not available in demo dataset	not available in demo dataset	not available in demo dataset	rr.com	Chrome	iOS	True	tablet	11	7.0	NaN	(not set)	m.youtube.com	referral	NaN	/watch	NaN	NaN	NaN	NaN	NaN
903645	Social	1970-01-01 00:00:00.020170104	2035095632074835075	2035095632074835075_1483570454	1483570454	1	1483570454	Americas	Northern America	United States	New York	New York NY	New York	att.net	Safari (in-app)	iOS	True	mobile	11	8.0	NaN	(not set)	m.facebook.com	referral	NaN	/	NaN	NaN	NaN	NaN	NaN
903646	Social	1970-01-01 00:00:00.020170104	567297396362985009	567297396362985009_1483581760	1483581760	1	1483581760	Oceania	Australasia	Australia	Victoria	(not set)	Melbourne	optusnet.com.au	Chrome	iOS	True	tablet	15	12.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/	NaN	NaN	NaN	NaN	NaN
903647	Social	1970-01-01 00:00:00.020170104	2140149974339316233	2140149974339316233_1483557808	1483557808	1	1483557808	Africa	Northern Africa	Egypt	not available in demo dataset	not available in demo dataset	not available in demo dataset	tedata.net	Chrome	Windows	False	desktop	16	11.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/ar/	NaN	NaN	NaN	NaN	NaN
903648	Social	1970-01-01 00:00:00.020170104	5123779100307500332	5123779100307500332_1483554750	1483554750	1	1483554750	Americas	Caribbean	Puerto Rico	not available in demo dataset	not available in demo dataset	not available in demo dataset	prtc.net	Chrome	Windows	False	desktop	17	15.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/	NaN	NaN	NaN	NaN	NaN
903649	Social	1970-01-01 00:00:00.020170104	7231728964973959842	7231728964973959842_1483543798	1483543798	1	1483543798	Asia	Southern Asia	Sri Lanka	not available in demo dataset	not available in demo dataset	not available in demo dataset	unknown.unknown	Chrome	Android	True	mobile	18	13.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/	NaN	NaN	NaN	NaN	NaN
903650	Social	1970-01-01 00:00:00.020170104	5744576632396406899	5744576632396406899_1483526434	1483526434	1	1483526434	Asia	Eastern Asia	South Korea	Seoul	(not set)	Seoul	unknown.unknown	Android Webview	Android	True	mobile	24	21.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/ko/	NaN	NaN	NaN	NaN	NaN
903651	Social	1970-01-01 00:00:00.020170104	2709355455991750775	2709355455991750775_1483592857	1483592857	1	1483592864	Asia	Southeast Asia	Indonesia	not available in demo dataset	not available in demo dataset	not available in demo dataset	unknown.unknown	Chrome	Windows	False	desktop	24	22.0	NaN	(not set)	facebook.com	referral	NaN	/l.php	NaN	NaN	NaN	NaN	NaN
903652	Social	1970-01-01 00:00:00.020170104	814900163617805053	0814900163617805053_1483574474	1483574474	1	1483574474	Americas	Central America	Mexico	not available in demo dataset	not available in demo dataset	not available in demo dataset	cybercable.net.mx	Chrome	Android	True	mobile	31	31.0	NaN	(not set)	youtube.com	referral	NaN	/yt/about/es-419/	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Open Punctuation

Space Separator

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Final Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin